/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package DAO;

/**
 *
 * @author DE SILVA
 */
public class Requetes {

    static String listePays ="SELECT * FROM pays WHERE ID_Pays=?;";
    static String lesPays="SELECT pays.ID_Pays, pays.nom FROM pays;";
    static String listeMaladiesApartirPays="select maladies.nom_Maladie from maladies, pays_maladies where maladies.ID_Maladie=pays_maladies.ID_Mal and pays_maladies.ID_Pays=?;";
    static String listeVaccinAPartirPays="select maladies.nom_Maladie, vaccination.type from maladies, vaccination where maladies.ID_Maladie=vaccination.ID_Mal and vaccination.ID_Pays=?;";
}
